import pandas as pd
from sqlalchemy import create_engine as ce

files={'ca_plot':'http://apps.fs.fed.us/fiadb-downloads/CA_PLOT.CSV','ca_plotgeom':'http://apps.fs.fed.us/fiadb-downloads/CA_PLOTGEOM.CSV','ca_cond':'http://apps.fs.fed.us/fiadb-downloads/CA_COND.CSV'}
engine=ce('postgresql:///biosum', echo=True)

for t in files.keys():
    df=pd.read_csv(files[t])
    df.columns=[i.lower() for i in df.columns]
    df.to_sql(t,engine)
    
